package com.ecoolex.discount.sales.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DiscountProductGiftCardExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DiscountProductGiftCardExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DiscountProductGiftCardExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DiscountProductGiftCardExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DiscountProductGiftCardExample example = new DiscountProductGiftCardExample();
        return example.createCriteria();
    }

    public DiscountProductGiftCardExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DiscountProductGiftCardExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DiscountProductGiftCardExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DiscountProductGiftCardExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DiscountProductGiftCardExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProductIdIsNull() {
            addCriterion("discountproductgiftcard.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("discountproductgiftcard.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("discountproductgiftcard.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("discountproductgiftcard.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNull() {
            addCriterion("discountproductgiftcard.CurrencyType is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNotNull() {
            addCriterion("discountproductgiftcard.CurrencyType is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualTo(String value) {
            addCriterion("discountproductgiftcard.CurrencyType =", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualTo(String value) {
            addCriterion("discountproductgiftcard.CurrencyType <>", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThan(String value) {
            addCriterion("discountproductgiftcard.CurrencyType >", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.CurrencyType >=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThan(String value) {
            addCriterion("discountproductgiftcard.CurrencyType <", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.CurrencyType <=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CurrencyType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLike(String value) {
            addCriterion("discountproductgiftcard.CurrencyType like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotLike(String value) {
            addCriterion("discountproductgiftcard.CurrencyType not like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIn(List<String> values) {
            addCriterion("discountproductgiftcard.CurrencyType in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotIn(List<String> values) {
            addCriterion("discountproductgiftcard.CurrencyType not in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.CurrencyType between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.CurrencyType not between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeIsNull() {
            addCriterion("discountproductgiftcard.CounterPriceType is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeIsNotNull() {
            addCriterion("discountproductgiftcard.CounterPriceType is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType =", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeNotEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType <>", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeGreaterThan(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType >", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType >=", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeLessThan(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType <", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.CounterPriceType <=", value, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.CounterPriceType in", values, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeNotIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.CounterPriceType not in", values, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.CounterPriceType between", value1, value2, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andCounterPriceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.CounterPriceType not between", value1, value2, "counterPriceType");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberIsNull() {
            addCriterion("discountproductgiftcard.MaxBuyNumber is null");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberIsNotNull() {
            addCriterion("discountproductgiftcard.MaxBuyNumber is not null");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber =", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberNotEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber <>", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberGreaterThan(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber >", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber >=", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberLessThan(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber <", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberLessThanOrEqualTo(Integer value) {
            addCriterion("discountproductgiftcard.MaxBuyNumber <=", value, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxBuyNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.MaxBuyNumber in", values, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberNotIn(List<Integer> values) {
            addCriterion("discountproductgiftcard.MaxBuyNumber not in", values, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.MaxBuyNumber between", value1, value2, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andMaxBuyNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproductgiftcard.MaxBuyNumber not between", value1, value2, "maxBuyNumber");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("discountproductgiftcard.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("discountproductgiftcard.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("discountproductgiftcard.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("discountproductgiftcard.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceIsNull() {
            addCriterion("discountproductgiftcard.MinCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceIsNotNull() {
            addCriterion("discountproductgiftcard.MinCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice =", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice <>", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice >", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice >=", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceLessThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice <", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MinCounterPrice <=", value, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MinCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.MinCounterPrice in", values, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.MinCounterPrice not in", values, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.MinCounterPrice between", value1, value2, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.MinCounterPrice not between", value1, value2, "minCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceIsNull() {
            addCriterion("discountproductgiftcard.MaxCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceIsNotNull() {
            addCriterion("discountproductgiftcard.MaxCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice =", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice <>", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice >", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice >=", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceLessThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice <", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.MaxCounterPrice <=", value, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.MaxCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.MaxCounterPrice in", values, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.MaxCounterPrice not in", values, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.MaxCounterPrice between", value1, value2, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.MaxCounterPrice not between", value1, value2, "maxCounterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentIsNull() {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentIsNotNull() {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent =", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentNotEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent <>", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentGreaterThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent >", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent >=", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentLessThan(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent <", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent <=", value, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CounterPriceDiscountPercent <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent in", values, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentNotIn(List<BigDecimal> values) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent not in", values, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent between", value1, value2, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andCounterPriceDiscountPercentNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountproductgiftcard.CounterPriceDiscountPercent not between", value1, value2, "counterPriceDiscountPercent");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("discountproductgiftcard.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("discountproductgiftcard.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("discountproductgiftcard.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("discountproductgiftcard.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("discountproductgiftcard.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproductgiftcard.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproductgiftcard.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("discountproductgiftcard.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("discountproductgiftcard.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("discountproductgiftcard.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("discountproductgiftcard.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("discountproductgiftcard.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("discountproductgiftcard.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("discountproductgiftcard.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("discountproductgiftcard.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("discountproductgiftcard.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("discountproductgiftcard.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproductgiftcard.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("discountproductgiftcard.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountproductgiftcard.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("discountproductgiftcard.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("discountproductgiftcard.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("discountproductgiftcard.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountproductgiftcard.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("discountproductgiftcard.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("discountproductgiftcard.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("discountproductgiftcard.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("discountproductgiftcard.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("discountproductgiftcard.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("discountproductgiftcard.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("discountproductgiftcard.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("discountproductgiftcard.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("discountproductgiftcard.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("discountproductgiftcard.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("discountproductgiftcard.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("discountproductgiftcard.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("discountproductgiftcard.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("discountproductgiftcard.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountproductgiftcard.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DiscountProductGiftCard.Column column) {
            addCriterion(new StringBuilder("discountproductgiftcard.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("discountproductgiftcard.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("discountproductgiftcard.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("discountproductgiftcard.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountproductgiftcard.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DiscountProductGiftCardExample example;

        protected Criteria(DiscountProductGiftCardExample example) {
            super();
            this.example = example;
        }

        public DiscountProductGiftCardExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DiscountProductGiftCard.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DiscountProductGiftCard.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.discount.sales.entity.DiscountProductGiftCardExample example);
    }
}